package com.xing.User.Service.Imp;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import com.xing.Common.Service.CommonService;
import com.xing.Common.Service.Imp.CommonServiceImp;
import com.xing.User.Service.UserService;

/**
*@author xingxing
*@version 
*@time 2017年10月19日 下午10:14:17 
*class explain：
*/
@Service("userService")
public class UserServiceImp extends CommonServiceImp implements UserService {

	@Override
	public List querymenu(String id) {
		String sql ="select m.mname,m.describe from t_user u  join t_user_role ur on u.id=ur.userid join t_role r on ur.roleid=r.rid " + 
				"join t_role_menu rm on r.rid=rm.roleid join t_menu m on rm.menuid=m.mid " + 
				"where u.id='"+id+"'";	
		return super.createSql(sql);
	}
}
